﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="PCV_GDPDataSet" targetNamespace="http://tempuri.org/PCV_GDPDataSet.xsd" xmlns:mstns="http://tempuri.org/PCV_GDPDataSet.xsd" xmlns="http://tempuri.org/PCV_GDPDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="PCV_GDPConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="PCV_GDPConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.IControl.My.MySettings.GlobalReference.Default.PCV_GDPConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BH_BanHangTableAdapter" GeneratorDataComponentClassName="BH_BanHangTableAdapter" Name="BH_BanHang" UserDataComponentName="BH_BanHangTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_GDPConnectionString (MySettings)" DbObjectName="PCV_GDP.dbo.BH_BanHang" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[BH_BanHang] WHERE (([ma] = @Original_ma) AND ((@IsNull_manghiepvu = 1 AND [manghiepvu] IS NULL) OR ([manghiepvu] = @Original_manghiepvu)) AND ((@IsNull_sochungtu = 1 AND [sochungtu] IS NULL) OR ([sochungtu] = @Original_sochungtu)) AND ((@IsNull_ngaychungtu = 1 AND [ngaychungtu] IS NULL) OR ([ngaychungtu] = @Original_ngaychungtu)) AND ((@IsNull_sohoadon = 1 AND [sohoadon] IS NULL) OR ([sohoadon] = @Original_sohoadon)) AND ((@IsNull_ngayhoadon = 1 AND [ngayhoadon] IS NULL) OR ([ngayhoadon] = @Original_ngayhoadon)) AND ((@IsNull_sotokhaiHQ = 1 AND [sotokhaiHQ] IS NULL) OR ([sotokhaiHQ] = @Original_sotokhaiHQ)) AND ((@IsNull_ngaytokhaiHQ = 1 AND [ngaytokhaiHQ] IS NULL) OR ([ngaytokhaiHQ] = @Original_ngaytokhaiHQ)) AND ((@IsNull_makhachhanguid = 1 AND [makhachhanguid] IS NULL) OR ([makhachhanguid] = @Original_makhachhanguid)) AND ((@IsNull_makhachhang = 1 AND [makhachhang] IS NULL) OR ([makhachhang] = @Original_makhachhang)) AND ((@IsNull_tenkhachhang = 1 AND [tenkhachhang] IS NULL) OR ([tenkhachhang] = @Original_tenkhachhang)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_soSO = 1 AND [soSO] IS NULL) OR ([soSO] = @Original_soSO)) AND ((@IsNull_hinhthucthanhtoan = 1 AND [hinhthucthanhtoan] IS NULL) OR ([hinhthucthanhtoan] = @Original_hinhthucthanhtoan)) AND ((@IsNull_ngaythanhtoan = 1 AND [ngaythanhtoan] IS NULL) OR ([ngaythanhtoan] = @Original_ngaythanhtoan)) AND ((@IsNull_dieukiengiaohang = 1 AND [dieukiengiaohang] IS NULL) OR ([dieukiengiaohang] = @Original_dieukiengiaohang)) AND ((@IsNull_tygiatokhaiHQ = 1 AND [tygiatokhaiHQ] IS NULL) OR ([tygiatokhaiHQ] = @Original_tygiatokhaiHQ)) AND ((@IsNull_diengiai = 1 AND [diengiai] IS NULL) OR ([diengiai] = @Original_diengiai)) AND ((@IsNull_loaitien = 1 AND [loaitien] IS NULL) OR ([loaitien] = @Original_loaitien)) AND ((@IsNull_tygianganhang = 1 AND [tygianganhang] IS NULL) OR ([tygianganhang] = @Original_tygianganhang)) AND ((@IsNull_nguyente = 1 AND [nguyente] IS NULL) OR ([nguyente] = @Original_nguyente)) AND ((@IsNull_thanhtienvnd = 1 AND [thanhtienvnd] IS NULL) OR ([thanhtienvnd] = @Original_thanhtienvnd)) AND ((@IsNull_phuongtienvanchuyen = 1 AND [phuongtienvanchuyen] IS NULL) OR ([phuongtienvanchuyen] = @Original_phuongtienvanchuyen)) AND ((@IsNull_nhanviensale = 1 AND [nhanviensale] IS NULL) OR ([nhanviensale] = @Original_nhanviensale)) AND ((@IsNull_phongban = 1 AND [phongban] IS NULL) OR ([phongban] = @Original_phongban)) AND ((@IsNull_machuongtrinhkhuyenmai = 1 AND [machuongtrinhkhuyenmai] IS NULL) OR ([machuongtrinhkhuyenmai] = @Original_machuongtrinhkhuyenmai)) AND ((@IsNull_banggia = 1 AND [banggia] IS NULL) OR ([banggia] = @Original_banggia)) AND ((@IsNull_sohopdong = 1 AND [sohopdong] IS NULL) OR ([sohopdong] = @Original_sohopdong)) AND ((@IsNull_kyketoan = 1 AND [kyketoan] IS NULL) OR ([kyketoan] = @Original_kyketoan)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ((@IsNull_loai = 1 AND [loai] IS NULL) OR ([loai] = @Original_loai)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_manghiepvu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_manghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sochungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaychungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayhoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sotokhaiHQ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sotokhaiHQ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sotokhaiHQ" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sotokhaiHQ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaytokhaiHQ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaytokhaiHQ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaytokhaiHQ" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaytokhaiHQ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_makhachhanguid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="makhachhanguid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_makhachhanguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="makhachhanguid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_makhachhang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="makhachhang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_makhachhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhachhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenkhachhang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenkhachhang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenkhachhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenkhachhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soSO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soSO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_soSO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="soSO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hinhthucthanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hinhthucthanhtoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hinhthucthanhtoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hinhthucthanhtoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaythanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaythanhtoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaythanhtoan" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhtoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dieukiengiaohang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dieukiengiaohang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dieukiengiaohang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dieukiengiaohang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tygiatokhaiHQ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tygiatokhaiHQ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tygiatokhaiHQ" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tygiatokhaiHQ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diengiai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diengiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaitien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaitien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaitien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaitien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tygianganhang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tygianganhang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tygianganhang" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tygianganhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nguyente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_nguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtienvnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtienvnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtienvnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phuongtienvanchuyen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phuongtienvanchuyen" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_phuongtienvanchuyen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phuongtienvanchuyen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhanviensale" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhanviensale" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nhanviensale" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhanviensale" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phongban" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phongban" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_phongban" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phongban" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_machuongtrinhkhuyenmai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machuongtrinhkhuyenmai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_machuongtrinhkhuyenmai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="machuongtrinhkhuyenmai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_banggia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_banggia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohopdong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohopdong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohopdong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohopdong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kyketoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_kyketoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[BH_BanHang] ([ma], [manghiepvu], [sochungtu], [ngaychungtu], [sohoadon], [ngayhoadon], [sotokhaiHQ], [ngaytokhaiHQ], [makhachhanguid], [makhachhang], [tenkhachhang], [diachi], [soSO], [hinhthucthanhtoan], [ngaythanhtoan], [dieukiengiaohang], [tygiatokhaiHQ], [diengiai], [loaitien], [tygianganhang], [nguyente], [thanhtienvnd], [phuongtienvanchuyen], [nhanviensale], [phongban], [machuongtrinhkhuyenmai], [banggia], [sohopdong], [kyketoan], [tinhtrang], [loai], [chinhanh]) VALUES (@ma, @manghiepvu, @sochungtu, @ngaychungtu, @sohoadon, @ngayhoadon, @sotokhaiHQ, @ngaytokhaiHQ, @makhachhanguid, @makhachhang, @tenkhachhang, @diachi, @soSO, @hinhthucthanhtoan, @ngaythanhtoan, @dieukiengiaohang, @tygiatokhaiHQ, @diengiai, @loaitien, @tygianganhang, @nguyente, @thanhtienvnd, @phuongtienvanchuyen, @nhanviensale, @phongban, @machuongtrinhkhuyenmai, @banggia, @sohopdong, @kyketoan, @tinhtrang, @loai, @chinhanh);
SELECT ma, manghiepvu, sochungtu, ngaychungtu, sohoadon, ngayhoadon, sotokhaiHQ, ngaytokhaiHQ, makhachhanguid, makhachhang, tenkhachhang, diachi, soSO, hinhthucthanhtoan, ngaythanhtoan, dieukiengiaohang, tygiatokhaiHQ, diengiai, loaitien, tygianganhang, nguyente, thanhtienvnd, phuongtienvanchuyen, nhanviensale, phongban, machuongtrinhkhuyenmai, banggia, sohopdong, kyketoan, tinhtrang, loai, chinhanh, id FROM BH_BanHang WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sotokhaiHQ" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sotokhaiHQ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaytokhaiHQ" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaytokhaiHQ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@makhachhanguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="makhachhanguid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makhachhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhachhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenkhachhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenkhachhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@soSO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="soSO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hinhthucthanhtoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hinhthucthanhtoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaythanhtoan" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhtoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dieukiengiaohang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dieukiengiaohang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tygiatokhaiHQ" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tygiatokhaiHQ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diengiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaitien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaitien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tygianganhang" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tygianganhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@nguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtienvnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@phuongtienvanchuyen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phuongtienvanchuyen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nhanviensale" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhanviensale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@phongban" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phongban" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@machuongtrinhkhuyenmai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="machuongtrinhkhuyenmai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@banggia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohopdong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohopdong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@kyketoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, manghiepvu, sochungtu, ngaychungtu, sohoadon, ngayhoadon, sotokhaiHQ, ngaytokhaiHQ, makhachhanguid, makhachhang, tenkhachhang, diachi, soSO, hinhthucthanhtoan, ngaythanhtoan, dieukiengiaohang, tygiatokhaiHQ, diengiai, loaitien, tygianganhang, nguyente, thanhtienvnd, phuongtienvanchuyen, nhanviensale, phongban, machuongtrinhkhuyenmai, banggia, sohopdong, kyketoan, tinhtrang, loai, chinhanh, id FROM dbo.BH_BanHang</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[BH_BanHang] SET [ma] = @ma, [manghiepvu] = @manghiepvu, [sochungtu] = @sochungtu, [ngaychungtu] = @ngaychungtu, [sohoadon] = @sohoadon, [ngayhoadon] = @ngayhoadon, [sotokhaiHQ] = @sotokhaiHQ, [ngaytokhaiHQ] = @ngaytokhaiHQ, [makhachhanguid] = @makhachhanguid, [makhachhang] = @makhachhang, [tenkhachhang] = @tenkhachhang, [diachi] = @diachi, [soSO] = @soSO, [hinhthucthanhtoan] = @hinhthucthanhtoan, [ngaythanhtoan] = @ngaythanhtoan, [dieukiengiaohang] = @dieukiengiaohang, [tygiatokhaiHQ] = @tygiatokhaiHQ, [diengiai] = @diengiai, [loaitien] = @loaitien, [tygianganhang] = @tygianganhang, [nguyente] = @nguyente, [thanhtienvnd] = @thanhtienvnd, [phuongtienvanchuyen] = @phuongtienvanchuyen, [nhanviensale] = @nhanviensale, [phongban] = @phongban, [machuongtrinhkhuyenmai] = @machuongtrinhkhuyenmai, [banggia] = @banggia, [sohopdong] = @sohopdong, [kyketoan] = @kyketoan, [tinhtrang] = @tinhtrang, [loai] = @loai, [chinhanh] = @chinhanh WHERE (([ma] = @Original_ma) AND ((@IsNull_manghiepvu = 1 AND [manghiepvu] IS NULL) OR ([manghiepvu] = @Original_manghiepvu)) AND ((@IsNull_sochungtu = 1 AND [sochungtu] IS NULL) OR ([sochungtu] = @Original_sochungtu)) AND ((@IsNull_ngaychungtu = 1 AND [ngaychungtu] IS NULL) OR ([ngaychungtu] = @Original_ngaychungtu)) AND ((@IsNull_sohoadon = 1 AND [sohoadon] IS NULL) OR ([sohoadon] = @Original_sohoadon)) AND ((@IsNull_ngayhoadon = 1 AND [ngayhoadon] IS NULL) OR ([ngayhoadon] = @Original_ngayhoadon)) AND ((@IsNull_sotokhaiHQ = 1 AND [sotokhaiHQ] IS NULL) OR ([sotokhaiHQ] = @Original_sotokhaiHQ)) AND ((@IsNull_ngaytokhaiHQ = 1 AND [ngaytokhaiHQ] IS NULL) OR ([ngaytokhaiHQ] = @Original_ngaytokhaiHQ)) AND ((@IsNull_makhachhanguid = 1 AND [makhachhanguid] IS NULL) OR ([makhachhanguid] = @Original_makhachhanguid)) AND ((@IsNull_makhachhang = 1 AND [makhachhang] IS NULL) OR ([makhachhang] = @Original_makhachhang)) AND ((@IsNull_tenkhachhang = 1 AND [tenkhachhang] IS NULL) OR ([tenkhachhang] = @Original_tenkhachhang)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_soSO = 1 AND [soSO] IS NULL) OR ([soSO] = @Original_soSO)) AND ((@IsNull_hinhthucthanhtoan = 1 AND [hinhthucthanhtoan] IS NULL) OR ([hinhthucthanhtoan] = @Original_hinhthucthanhtoan)) AND ((@IsNull_ngaythanhtoan = 1 AND [ngaythanhtoan] IS NULL) OR ([ngaythanhtoan] = @Original_ngaythanhtoan)) AND ((@IsNull_dieukiengiaohang = 1 AND [dieukiengiaohang] IS NULL) OR ([dieukiengiaohang] = @Original_dieukiengiaohang)) AND ((@IsNull_tygiatokhaiHQ = 1 AND [tygiatokhaiHQ] IS NULL) OR ([tygiatokhaiHQ] = @Original_tygiatokhaiHQ)) AND ((@IsNull_diengiai = 1 AND [diengiai] IS NULL) OR ([diengiai] = @Original_diengiai)) AND ((@IsNull_loaitien = 1 AND [loaitien] IS NULL) OR ([loaitien] = @Original_loaitien)) AND ((@IsNull_tygianganhang = 1 AND [tygianganhang] IS NULL) OR ([tygianganhang] = @Original_tygianganhang)) AND ((@IsNull_nguyente = 1 AND [nguyente] IS NULL) OR ([nguyente] = @Original_nguyente)) AND ((@IsNull_thanhtienvnd = 1 AND [thanhtienvnd] IS NULL) OR ([thanhtienvnd] = @Original_thanhtienvnd)) AND ((@IsNull_phuongtienvanchuyen = 1 AND [phuongtienvanchuyen] IS NULL) OR ([phuongtienvanchuyen] = @Original_phuongtienvanchuyen)) AND ((@IsNull_nhanviensale = 1 AND [nhanviensale] IS NULL) OR ([nhanviensale] = @Original_nhanviensale)) AND ((@IsNull_phongban = 1 AND [phongban] IS NULL) OR ([phongban] = @Original_phongban)) AND ((@IsNull_machuongtrinhkhuyenmai = 1 AND [machuongtrinhkhuyenmai] IS NULL) OR ([machuongtrinhkhuyenmai] = @Original_machuongtrinhkhuyenmai)) AND ((@IsNull_banggia = 1 AND [banggia] IS NULL) OR ([banggia] = @Original_banggia)) AND ((@IsNull_sohopdong = 1 AND [sohopdong] IS NULL) OR ([sohopdong] = @Original_sohopdong)) AND ((@IsNull_kyketoan = 1 AND [kyketoan] IS NULL) OR ([kyketoan] = @Original_kyketoan)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ((@IsNull_loai = 1 AND [loai] IS NULL) OR ([loai] = @Original_loai)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id));
SELECT ma, manghiepvu, sochungtu, ngaychungtu, sohoadon, ngayhoadon, sotokhaiHQ, ngaytokhaiHQ, makhachhanguid, makhachhang, tenkhachhang, diachi, soSO, hinhthucthanhtoan, ngaythanhtoan, dieukiengiaohang, tygiatokhaiHQ, diengiai, loaitien, tygianganhang, nguyente, thanhtienvnd, phuongtienvanchuyen, nhanviensale, phongban, machuongtrinhkhuyenmai, banggia, sohopdong, kyketoan, tinhtrang, loai, chinhanh, id FROM BH_BanHang WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sotokhaiHQ" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sotokhaiHQ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaytokhaiHQ" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaytokhaiHQ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@makhachhanguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="makhachhanguid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makhachhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhachhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenkhachhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenkhachhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@soSO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="soSO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hinhthucthanhtoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hinhthucthanhtoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaythanhtoan" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhtoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dieukiengiaohang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dieukiengiaohang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tygiatokhaiHQ" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tygiatokhaiHQ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diengiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaitien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaitien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tygianganhang" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tygianganhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@nguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtienvnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@phuongtienvanchuyen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phuongtienvanchuyen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nhanviensale" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhanviensale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@phongban" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phongban" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@machuongtrinhkhuyenmai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="machuongtrinhkhuyenmai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@banggia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohopdong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohopdong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@kyketoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_manghiepvu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_manghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sochungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaychungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayhoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sotokhaiHQ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sotokhaiHQ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sotokhaiHQ" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sotokhaiHQ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaytokhaiHQ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaytokhaiHQ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaytokhaiHQ" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaytokhaiHQ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_makhachhanguid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="makhachhanguid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_makhachhanguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="makhachhanguid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_makhachhang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="makhachhang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_makhachhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhachhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenkhachhang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenkhachhang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenkhachhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenkhachhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soSO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soSO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_soSO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="soSO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hinhthucthanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hinhthucthanhtoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hinhthucthanhtoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hinhthucthanhtoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaythanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaythanhtoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaythanhtoan" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhtoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dieukiengiaohang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dieukiengiaohang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dieukiengiaohang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dieukiengiaohang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tygiatokhaiHQ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tygiatokhaiHQ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tygiatokhaiHQ" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tygiatokhaiHQ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diengiai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diengiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaitien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaitien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaitien" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaitien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tygianganhang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tygianganhang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tygianganhang" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tygianganhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nguyente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_nguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="nguyente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtienvnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtienvnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtienvnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phuongtienvanchuyen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phuongtienvanchuyen" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_phuongtienvanchuyen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phuongtienvanchuyen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhanviensale" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhanviensale" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nhanviensale" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhanviensale" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phongban" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phongban" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_phongban" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phongban" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_machuongtrinhkhuyenmai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machuongtrinhkhuyenmai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_machuongtrinhkhuyenmai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="machuongtrinhkhuyenmai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_banggia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_banggia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohopdong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohopdong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohopdong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohopdong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kyketoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_kyketoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="PCV_GDP.dbo.BH_BanHang" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="manghiepvu" DataSetColumn="manghiepvu" />
              <Mapping SourceColumn="sochungtu" DataSetColumn="sochungtu" />
              <Mapping SourceColumn="ngaychungtu" DataSetColumn="ngaychungtu" />
              <Mapping SourceColumn="sohoadon" DataSetColumn="sohoadon" />
              <Mapping SourceColumn="ngayhoadon" DataSetColumn="ngayhoadon" />
              <Mapping SourceColumn="sotokhaiHQ" DataSetColumn="sotokhaiHQ" />
              <Mapping SourceColumn="ngaytokhaiHQ" DataSetColumn="ngaytokhaiHQ" />
              <Mapping SourceColumn="makhachhanguid" DataSetColumn="makhachhanguid" />
              <Mapping SourceColumn="makhachhang" DataSetColumn="makhachhang" />
              <Mapping SourceColumn="tenkhachhang" DataSetColumn="tenkhachhang" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="soSO" DataSetColumn="soSO" />
              <Mapping SourceColumn="hinhthucthanhtoan" DataSetColumn="hinhthucthanhtoan" />
              <Mapping SourceColumn="ngaythanhtoan" DataSetColumn="ngaythanhtoan" />
              <Mapping SourceColumn="dieukiengiaohang" DataSetColumn="dieukiengiaohang" />
              <Mapping SourceColumn="tygiatokhaiHQ" DataSetColumn="tygiatokhaiHQ" />
              <Mapping SourceColumn="diengiai" DataSetColumn="diengiai" />
              <Mapping SourceColumn="loaitien" DataSetColumn="loaitien" />
              <Mapping SourceColumn="tygianganhang" DataSetColumn="tygianganhang" />
              <Mapping SourceColumn="nguyente" DataSetColumn="nguyente" />
              <Mapping SourceColumn="thanhtienvnd" DataSetColumn="thanhtienvnd" />
              <Mapping SourceColumn="phuongtienvanchuyen" DataSetColumn="phuongtienvanchuyen" />
              <Mapping SourceColumn="nhanviensale" DataSetColumn="nhanviensale" />
              <Mapping SourceColumn="phongban" DataSetColumn="phongban" />
              <Mapping SourceColumn="machuongtrinhkhuyenmai" DataSetColumn="machuongtrinhkhuyenmai" />
              <Mapping SourceColumn="banggia" DataSetColumn="banggia" />
              <Mapping SourceColumn="sohopdong" DataSetColumn="sohopdong" />
              <Mapping SourceColumn="kyketoan" DataSetColumn="kyketoan" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
              <Mapping SourceColumn="loai" DataSetColumn="loai" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BH_BanHangChiTietTableAdapter" GeneratorDataComponentClassName="BH_BanHangChiTietTableAdapter" Name="BH_BanHangChiTiet" UserDataComponentName="BH_BanHangChiTietTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_GDPConnectionString (MySettings)" DbObjectName="PCV_GDP.dbo.BH_BanHangChiTiet" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[BH_BanHangChiTiet] WHERE (([ma] = @Original_ma) AND ((@IsNull_manghiepvu = 1 AND [manghiepvu] IS NULL) OR ([manghiepvu] = @Original_manghiepvu)) AND ((@IsNull_sochungtu = 1 AND [sochungtu] IS NULL) OR ([sochungtu] = @Original_sochungtu)) AND ((@IsNull_ngaychungtu = 1 AND [ngaychungtu] IS NULL) OR ([ngaychungtu] = @Original_ngaychungtu)) AND ((@IsNull_sohoadon = 1 AND [sohoadon] IS NULL) OR ([sohoadon] = @Original_sohoadon)) AND ((@IsNull_ngayhoadon = 1 AND [ngayhoadon] IS NULL) OR ([ngayhoadon] = @Original_ngayhoadon)) AND ((@IsNull_taikhoanno = 1 AND [taikhoanno] IS NULL) OR ([taikhoanno] = @Original_taikhoanno)) AND ((@IsNull_taikhoanco = 1 AND [taikhoanco] IS NULL) OR ([taikhoanco] = @Original_taikhoanco)) AND ((@IsNull_madonviuid = 1 AND [madonviuid] IS NULL) OR ([madonviuid] = @Original_madonviuid)) AND ((@IsNull_madonvi = 1 AND [madonvi] IS NULL) OR ([madonvi] = @Original_madonvi)) AND ((@IsNull_tendonvi = 1 AND [tendonvi] IS NULL) OR ([tendonvi] = @Original_tendonvi)) AND ((@IsNull_diachidonvi = 1 AND [diachidonvi] IS NULL) OR ([diachidonvi] = @Original_diachidonvi)) AND ((@IsNull_diengiai = 1 AND [diengiai] IS NULL) OR ([diengiai] = @Original_diengiai)) AND ((@IsNull_mafifo = 1 AND [mafifo] IS NULL) OR ([mafifo] = @Original_mafifo)) AND ((@IsNull_mahanguid = 1 AND [mahanguid] IS NULL) OR ([mahanguid] = @Original_mahanguid)) AND ((@IsNull_mahang = 1 AND [mahang] IS NULL) OR ([mahang] = @Original_mahang)) AND ((@IsNull_tenhang = 1 AND [tenhang] IS NULL) OR ([tenhang] = @Original_tenhang)) AND ((@IsNull_solo = 1 AND [solo] IS NULL) OR ([solo] = @Original_solo)) AND ((@IsNull_hsd = 1 AND [hsd] IS NULL) OR ([hsd] = @Original_hsd)) AND ((@IsNull_quicach = 1 AND [quicach] IS NULL) OR ([quicach] = @Original_quicach)) AND ((@IsNull_dvt = 1 AND [dvt] IS NULL) OR ([dvt] = @Original_dvt)) AND ((@IsNull_soluongso = 1 AND [soluongso] IS NULL) OR ([soluongso] = @Original_soluongso)) AND ((@IsNull_soluonggiao = 1 AND [soluonggiao] IS NULL) OR ([soluonggiao] = @Original_soluonggiao)) AND ((@IsNull_dongianguyente = 1 AND [dongianguyente] IS NULL) OR ([dongianguyente] = @Original_dongianguyente)) AND ((@IsNull_dongiavnd = 1 AND [dongiavnd] IS NULL) OR ([dongiavnd] = @Original_dongiavnd)) AND ((@IsNull_thanhtiennguyente = 1 AND [thanhtiennguyente] IS NULL) OR ([thanhtiennguyente] = @Original_thanhtiennguyente)) AND ((@IsNull_thanhtienvnd = 1 AND [thanhtienvnd] IS NULL) OR ([thanhtienvnd] = @Original_thanhtienvnd)) AND ((@IsNull_tilethuegtgt = 1 AND [tilethuegtgt] IS NULL) OR ([tilethuegtgt] = @Original_tilethuegtgt)) AND ((@IsNull_tienthuegtgt = 1 AND [tienthuegtgt] IS NULL) OR ([tienthuegtgt] = @Original_tienthuegtgt)) AND ((@IsNull_taikhoanthuegtgt = 1 AND [taikhoanthuegtgt] IS NULL) OR ([taikhoanthuegtgt] = @Original_taikhoanthuegtgt)) AND ((@IsNull_chiphiban = 1 AND [chiphiban] IS NULL) OR ([chiphiban] = @Original_chiphiban)) AND ((@IsNull_tilethuenk = 1 AND [tilethuenk] IS NULL) OR ([tilethuenk] = @Original_tilethuenk)) AND ((@IsNull_tienthuenk = 1 AND [tienthuenk] IS NULL) OR ([tienthuenk] = @Original_tienthuenk)) AND ((@IsNull_taikhoanthuenk = 1 AND [taikhoanthuenk] IS NULL) OR ([taikhoanthuenk] = @Original_taikhoanthuenk)) AND ((@IsNull_taikhoanchietkhau = 1 AND [taikhoanchietkhau] IS NULL) OR ([taikhoanchietkhau] = @Original_taikhoanchietkhau)) AND ((@IsNull_chietkhau = 1 AND [chietkhau] IS NULL) OR ([chietkhau] = @Original_chietkhau)) AND ((@IsNull_nhomhd = 1 AND [nhomhd] IS NULL) OR ([nhomhd] = @Original_nhomhd)) AND ((@IsNull_chenhlech = 1 AND [chenhlech] IS NULL) OR ([chenhlech] = @Original_chenhlech)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ((@IsNull_kyketoan = 1 AND [kyketoan] IS NULL) OR ([kyketoan] = @Original_kyketoan)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ((@IsNull_loai = 1 AND [loai] IS NULL) OR ([loai] = @Original_loai)) AND ([uid] = @Original_uid) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_manghiepvu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_manghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sochungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaychungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayhoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanco" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanco" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanco" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanco" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_madonviuid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="madonviuid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_madonviuid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="madonviuid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_madonvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="madonvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_madonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madonvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tendonvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tendonvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tendonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendonvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachidonvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachidonvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachidonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachidonvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diengiai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diengiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mafifo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mafifo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mafifo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mafifo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mahanguid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mahanguid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_mahanguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="mahanguid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mahang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mahang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mahang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenhang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_solo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hsd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hsd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_hsd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="hsd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_quicach" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_quicach" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dvt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dvt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dvt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dvt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluongso" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluongso" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluongso" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongso" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluonggiao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluonggiao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluonggiao" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluonggiao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dongianguyente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dongianguyente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_dongianguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongianguyente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dongiavnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dongiavnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_dongiavnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongiavnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtiennguyente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtiennguyente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtiennguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiennguyente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtienvnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtienvnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtienvnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tilethuegtgt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tilethuegtgt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tilethuegtgt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tilethuegtgt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tienthuegtgt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tienthuegtgt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tienthuegtgt" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienthuegtgt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanthuegtgt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanthuegtgt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanthuegtgt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanthuegtgt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chiphiban" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chiphiban" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_chiphiban" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chiphiban" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tilethuenk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tilethuenk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tilethuenk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tilethuenk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tienthuenk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tienthuenk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tienthuenk" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienthuenk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanthuenk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanthuenk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanthuenk" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanthuenk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanchietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanchietkhau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanchietkhau" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanchietkhau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhomhd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhomhd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nhomhd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhomhd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chenhlech" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chenhlech" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_chenhlech" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chenhlech" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kyketoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_kyketoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[BH_BanHangChiTiet] ([ma], [manghiepvu], [sochungtu], [ngaychungtu], [sohoadon], [ngayhoadon], [taikhoanno], [taikhoanco], [madonviuid], [madonvi], [tendonvi], [diachidonvi], [diengiai], [mafifo], [mahanguid], [mahang], [tenhang], [solo], [hsd], [quicach], [dvt], [soluongso], [soluonggiao], [dongianguyente], [dongiavnd], [thanhtiennguyente], [thanhtienvnd], [tilethuegtgt], [tienthuegtgt], [taikhoanthuegtgt], [chiphiban], [tilethuenk], [tienthuenk], [taikhoanthuenk], [taikhoanchietkhau], [chietkhau], [nhomhd], [chenhlech], [tinhtrang], [kyketoan], [chinhanh], [loai], [uid]) VALUES (@ma, @manghiepvu, @sochungtu, @ngaychungtu, @sohoadon, @ngayhoadon, @taikhoanno, @taikhoanco, @madonviuid, @madonvi, @tendonvi, @diachidonvi, @diengiai, @mafifo, @mahanguid, @mahang, @tenhang, @solo, @hsd, @quicach, @dvt, @soluongso, @soluonggiao, @dongianguyente, @dongiavnd, @thanhtiennguyente, @thanhtienvnd, @tilethuegtgt, @tienthuegtgt, @taikhoanthuegtgt, @chiphiban, @tilethuenk, @tienthuenk, @taikhoanthuenk, @taikhoanchietkhau, @chietkhau, @nhomhd, @chenhlech, @tinhtrang, @kyketoan, @chinhanh, @loai, @uid);
SELECT ma, manghiepvu, sochungtu, ngaychungtu, sohoadon, ngayhoadon, taikhoanno, taikhoanco, madonviuid, madonvi, tendonvi, diachidonvi, diengiai, mafifo, mahanguid, mahang, tenhang, solo, hsd, quicach, dvt, soluongso, soluonggiao, dongianguyente, dongiavnd, thanhtiennguyente, thanhtienvnd, tilethuegtgt, tienthuegtgt, taikhoanthuegtgt, chiphiban, tilethuenk, tienthuenk, taikhoanthuenk, taikhoanchietkhau, chietkhau, nhomhd, chenhlech, tinhtrang, kyketoan, chinhanh, loai, uid, id FROM BH_BanHangChiTiet WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanco" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanco" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@madonviuid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="madonviuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@madonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madonvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tendonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendonvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachidonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachidonvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diengiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mafifo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mafifo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@mahanguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="mahanguid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mahang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@hsd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="hsd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@quicach" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dvt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dvt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluongso" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongso" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluonggiao" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluonggiao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@dongianguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongianguyente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@dongiavnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongiavnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtiennguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiennguyente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtienvnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tilethuegtgt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tilethuegtgt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tienthuegtgt" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienthuegtgt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanthuegtgt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanthuegtgt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@chiphiban" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chiphiban" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tilethuenk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tilethuenk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tienthuenk" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienthuenk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanthuenk" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanthuenk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanchietkhau" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanchietkhau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nhomhd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhomhd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@chenhlech" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chenhlech" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@kyketoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, manghiepvu, sochungtu, ngaychungtu, sohoadon, ngayhoadon, taikhoanno, taikhoanco, madonviuid, madonvi, tendonvi, diachidonvi, diengiai, mafifo, mahanguid, mahang, tenhang, solo, hsd, quicach, dvt, soluongso, soluonggiao, dongianguyente, dongiavnd, thanhtiennguyente, thanhtienvnd, tilethuegtgt, tienthuegtgt, taikhoanthuegtgt, chiphiban, tilethuenk, tienthuenk, taikhoanthuenk, taikhoanchietkhau, chietkhau, nhomhd, chenhlech, tinhtrang, kyketoan, chinhanh, loai, uid, id FROM dbo.BH_BanHangChiTiet</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[BH_BanHangChiTiet] SET [ma] = @ma, [manghiepvu] = @manghiepvu, [sochungtu] = @sochungtu, [ngaychungtu] = @ngaychungtu, [sohoadon] = @sohoadon, [ngayhoadon] = @ngayhoadon, [taikhoanno] = @taikhoanno, [taikhoanco] = @taikhoanco, [madonviuid] = @madonviuid, [madonvi] = @madonvi, [tendonvi] = @tendonvi, [diachidonvi] = @diachidonvi, [diengiai] = @diengiai, [mafifo] = @mafifo, [mahanguid] = @mahanguid, [mahang] = @mahang, [tenhang] = @tenhang, [solo] = @solo, [hsd] = @hsd, [quicach] = @quicach, [dvt] = @dvt, [soluongso] = @soluongso, [soluonggiao] = @soluonggiao, [dongianguyente] = @dongianguyente, [dongiavnd] = @dongiavnd, [thanhtiennguyente] = @thanhtiennguyente, [thanhtienvnd] = @thanhtienvnd, [tilethuegtgt] = @tilethuegtgt, [tienthuegtgt] = @tienthuegtgt, [taikhoanthuegtgt] = @taikhoanthuegtgt, [chiphiban] = @chiphiban, [tilethuenk] = @tilethuenk, [tienthuenk] = @tienthuenk, [taikhoanthuenk] = @taikhoanthuenk, [taikhoanchietkhau] = @taikhoanchietkhau, [chietkhau] = @chietkhau, [nhomhd] = @nhomhd, [chenhlech] = @chenhlech, [tinhtrang] = @tinhtrang, [kyketoan] = @kyketoan, [chinhanh] = @chinhanh, [loai] = @loai, [uid] = @uid WHERE (([ma] = @Original_ma) AND ((@IsNull_manghiepvu = 1 AND [manghiepvu] IS NULL) OR ([manghiepvu] = @Original_manghiepvu)) AND ((@IsNull_sochungtu = 1 AND [sochungtu] IS NULL) OR ([sochungtu] = @Original_sochungtu)) AND ((@IsNull_ngaychungtu = 1 AND [ngaychungtu] IS NULL) OR ([ngaychungtu] = @Original_ngaychungtu)) AND ((@IsNull_sohoadon = 1 AND [sohoadon] IS NULL) OR ([sohoadon] = @Original_sohoadon)) AND ((@IsNull_ngayhoadon = 1 AND [ngayhoadon] IS NULL) OR ([ngayhoadon] = @Original_ngayhoadon)) AND ((@IsNull_taikhoanno = 1 AND [taikhoanno] IS NULL) OR ([taikhoanno] = @Original_taikhoanno)) AND ((@IsNull_taikhoanco = 1 AND [taikhoanco] IS NULL) OR ([taikhoanco] = @Original_taikhoanco)) AND ((@IsNull_madonviuid = 1 AND [madonviuid] IS NULL) OR ([madonviuid] = @Original_madonviuid)) AND ((@IsNull_madonvi = 1 AND [madonvi] IS NULL) OR ([madonvi] = @Original_madonvi)) AND ((@IsNull_tendonvi = 1 AND [tendonvi] IS NULL) OR ([tendonvi] = @Original_tendonvi)) AND ((@IsNull_diachidonvi = 1 AND [diachidonvi] IS NULL) OR ([diachidonvi] = @Original_diachidonvi)) AND ((@IsNull_diengiai = 1 AND [diengiai] IS NULL) OR ([diengiai] = @Original_diengiai)) AND ((@IsNull_mafifo = 1 AND [mafifo] IS NULL) OR ([mafifo] = @Original_mafifo)) AND ((@IsNull_mahanguid = 1 AND [mahanguid] IS NULL) OR ([mahanguid] = @Original_mahanguid)) AND ((@IsNull_mahang = 1 AND [mahang] IS NULL) OR ([mahang] = @Original_mahang)) AND ((@IsNull_tenhang = 1 AND [tenhang] IS NULL) OR ([tenhang] = @Original_tenhang)) AND ((@IsNull_solo = 1 AND [solo] IS NULL) OR ([solo] = @Original_solo)) AND ((@IsNull_hsd = 1 AND [hsd] IS NULL) OR ([hsd] = @Original_hsd)) AND ((@IsNull_quicach = 1 AND [quicach] IS NULL) OR ([quicach] = @Original_quicach)) AND ((@IsNull_dvt = 1 AND [dvt] IS NULL) OR ([dvt] = @Original_dvt)) AND ((@IsNull_soluongso = 1 AND [soluongso] IS NULL) OR ([soluongso] = @Original_soluongso)) AND ((@IsNull_soluonggiao = 1 AND [soluonggiao] IS NULL) OR ([soluonggiao] = @Original_soluonggiao)) AND ((@IsNull_dongianguyente = 1 AND [dongianguyente] IS NULL) OR ([dongianguyente] = @Original_dongianguyente)) AND ((@IsNull_dongiavnd = 1 AND [dongiavnd] IS NULL) OR ([dongiavnd] = @Original_dongiavnd)) AND ((@IsNull_thanhtiennguyente = 1 AND [thanhtiennguyente] IS NULL) OR ([thanhtiennguyente] = @Original_thanhtiennguyente)) AND ((@IsNull_thanhtienvnd = 1 AND [thanhtienvnd] IS NULL) OR ([thanhtienvnd] = @Original_thanhtienvnd)) AND ((@IsNull_tilethuegtgt = 1 AND [tilethuegtgt] IS NULL) OR ([tilethuegtgt] = @Original_tilethuegtgt)) AND ((@IsNull_tienthuegtgt = 1 AND [tienthuegtgt] IS NULL) OR ([tienthuegtgt] = @Original_tienthuegtgt)) AND ((@IsNull_taikhoanthuegtgt = 1 AND [taikhoanthuegtgt] IS NULL) OR ([taikhoanthuegtgt] = @Original_taikhoanthuegtgt)) AND ((@IsNull_chiphiban = 1 AND [chiphiban] IS NULL) OR ([chiphiban] = @Original_chiphiban)) AND ((@IsNull_tilethuenk = 1 AND [tilethuenk] IS NULL) OR ([tilethuenk] = @Original_tilethuenk)) AND ((@IsNull_tienthuenk = 1 AND [tienthuenk] IS NULL) OR ([tienthuenk] = @Original_tienthuenk)) AND ((@IsNull_taikhoanthuenk = 1 AND [taikhoanthuenk] IS NULL) OR ([taikhoanthuenk] = @Original_taikhoanthuenk)) AND ((@IsNull_taikhoanchietkhau = 1 AND [taikhoanchietkhau] IS NULL) OR ([taikhoanchietkhau] = @Original_taikhoanchietkhau)) AND ((@IsNull_chietkhau = 1 AND [chietkhau] IS NULL) OR ([chietkhau] = @Original_chietkhau)) AND ((@IsNull_nhomhd = 1 AND [nhomhd] IS NULL) OR ([nhomhd] = @Original_nhomhd)) AND ((@IsNull_chenhlech = 1 AND [chenhlech] IS NULL) OR ([chenhlech] = @Original_chenhlech)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ((@IsNull_kyketoan = 1 AND [kyketoan] IS NULL) OR ([kyketoan] = @Original_kyketoan)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ((@IsNull_loai = 1 AND [loai] IS NULL) OR ([loai] = @Original_loai)) AND ([uid] = @Original_uid) AND ([id] = @Original_id));
SELECT ma, manghiepvu, sochungtu, ngaychungtu, sohoadon, ngayhoadon, taikhoanno, taikhoanco, madonviuid, madonvi, tendonvi, diachidonvi, diengiai, mafifo, mahanguid, mahang, tenhang, solo, hsd, quicach, dvt, soluongso, soluonggiao, dongianguyente, dongiavnd, thanhtiennguyente, thanhtienvnd, tilethuegtgt, tienthuegtgt, taikhoanthuegtgt, chiphiban, tilethuenk, tienthuenk, taikhoanthuenk, taikhoanchietkhau, chietkhau, nhomhd, chenhlech, tinhtrang, kyketoan, chinhanh, loai, uid, id FROM BH_BanHangChiTiet WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanco" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanco" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@madonviuid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="madonviuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@madonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madonvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tendonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendonvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachidonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachidonvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diengiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mafifo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mafifo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@mahanguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="mahanguid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mahang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@hsd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="hsd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@quicach" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dvt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dvt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluongso" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongso" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluonggiao" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluonggiao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@dongianguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongianguyente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@dongiavnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongiavnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtiennguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiennguyente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtienvnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tilethuegtgt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tilethuegtgt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tienthuegtgt" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienthuegtgt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanthuegtgt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanthuegtgt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@chiphiban" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chiphiban" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tilethuenk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tilethuenk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tienthuenk" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienthuenk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanthuenk" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanthuenk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanchietkhau" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanchietkhau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nhomhd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhomhd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@chenhlech" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chenhlech" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@kyketoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_manghiepvu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_manghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sochungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaychungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayhoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanco" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanco" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanco" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanco" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_madonviuid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="madonviuid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_madonviuid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="madonviuid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_madonvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="madonvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_madonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madonvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tendonvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tendonvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tendonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendonvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachidonvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachidonvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachidonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachidonvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diengiai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diengiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mafifo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mafifo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mafifo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mafifo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mahanguid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mahanguid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_mahanguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="mahanguid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mahang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mahang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mahang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenhang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_solo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hsd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hsd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_hsd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="hsd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_quicach" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_quicach" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dvt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dvt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dvt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dvt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluongso" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluongso" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluongso" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluongso" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluonggiao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluonggiao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluonggiao" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluonggiao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dongianguyente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dongianguyente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_dongianguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongianguyente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dongiavnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dongiavnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_dongiavnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongiavnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtiennguyente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtiennguyente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtiennguyente" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtiennguyente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtienvnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtienvnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtienvnd" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtienvnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tilethuegtgt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tilethuegtgt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tilethuegtgt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tilethuegtgt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tienthuegtgt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tienthuegtgt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tienthuegtgt" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienthuegtgt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanthuegtgt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanthuegtgt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanthuegtgt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanthuegtgt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chiphiban" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chiphiban" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_chiphiban" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chiphiban" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tilethuenk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tilethuenk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tilethuenk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tilethuenk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tienthuenk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tienthuenk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tienthuenk" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienthuenk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanthuenk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanthuenk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanthuenk" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanthuenk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanchietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanchietkhau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanchietkhau" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanchietkhau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhomhd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhomhd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nhomhd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhomhd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chenhlech" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chenhlech" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_chenhlech" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chenhlech" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kyketoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_kyketoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="kyketoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="PCV_GDP.dbo.BH_BanHangChiTiet" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="manghiepvu" DataSetColumn="manghiepvu" />
              <Mapping SourceColumn="sochungtu" DataSetColumn="sochungtu" />
              <Mapping SourceColumn="ngaychungtu" DataSetColumn="ngaychungtu" />
              <Mapping SourceColumn="sohoadon" DataSetColumn="sohoadon" />
              <Mapping SourceColumn="ngayhoadon" DataSetColumn="ngayhoadon" />
              <Mapping SourceColumn="taikhoanno" DataSetColumn="taikhoanno" />
              <Mapping SourceColumn="taikhoanco" DataSetColumn="taikhoanco" />
              <Mapping SourceColumn="madonviuid" DataSetColumn="madonviuid" />
              <Mapping SourceColumn="madonvi" DataSetColumn="madonvi" />
              <Mapping SourceColumn="tendonvi" DataSetColumn="tendonvi" />
              <Mapping SourceColumn="diachidonvi" DataSetColumn="diachidonvi" />
              <Mapping SourceColumn="diengiai" DataSetColumn="diengiai" />
              <Mapping SourceColumn="mafifo" DataSetColumn="mafifo" />
              <Mapping SourceColumn="mahanguid" DataSetColumn="mahanguid" />
              <Mapping SourceColumn="mahang" DataSetColumn="mahang" />
              <Mapping SourceColumn="tenhang" DataSetColumn="tenhang" />
              <Mapping SourceColumn="solo" DataSetColumn="solo" />
              <Mapping SourceColumn="hsd" DataSetColumn="hsd" />
              <Mapping SourceColumn="quicach" DataSetColumn="quicach" />
              <Mapping SourceColumn="dvt" DataSetColumn="dvt" />
              <Mapping SourceColumn="soluongso" DataSetColumn="soluongso" />
              <Mapping SourceColumn="soluonggiao" DataSetColumn="soluonggiao" />
              <Mapping SourceColumn="dongianguyente" DataSetColumn="dongianguyente" />
              <Mapping SourceColumn="dongiavnd" DataSetColumn="dongiavnd" />
              <Mapping SourceColumn="thanhtiennguyente" DataSetColumn="thanhtiennguyente" />
              <Mapping SourceColumn="thanhtienvnd" DataSetColumn="thanhtienvnd" />
              <Mapping SourceColumn="tilethuegtgt" DataSetColumn="tilethuegtgt" />
              <Mapping SourceColumn="tienthuegtgt" DataSetColumn="tienthuegtgt" />
              <Mapping SourceColumn="taikhoanthuegtgt" DataSetColumn="taikhoanthuegtgt" />
              <Mapping SourceColumn="chiphiban" DataSetColumn="chiphiban" />
              <Mapping SourceColumn="tilethuenk" DataSetColumn="tilethuenk" />
              <Mapping SourceColumn="tienthuenk" DataSetColumn="tienthuenk" />
              <Mapping SourceColumn="taikhoanthuenk" DataSetColumn="taikhoanthuenk" />
              <Mapping SourceColumn="taikhoanchietkhau" DataSetColumn="taikhoanchietkhau" />
              <Mapping SourceColumn="chietkhau" DataSetColumn="chietkhau" />
              <Mapping SourceColumn="nhomhd" DataSetColumn="nhomhd" />
              <Mapping SourceColumn="chenhlech" DataSetColumn="chenhlech" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
              <Mapping SourceColumn="kyketoan" DataSetColumn="kyketoan" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="loai" DataSetColumn="loai" />
              <Mapping SourceColumn="uid" DataSetColumn="uid" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BH_BanHangThueTableAdapter" GeneratorDataComponentClassName="BH_BanHangThueTableAdapter" Name="BH_BanHangThue" UserDataComponentName="BH_BanHangThueTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_GDPConnectionString (MySettings)" DbObjectName="PCV_GDP.dbo.BH_BanHangThue" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[BH_BanHangThue] WHERE (([ma] = @Original_ma) AND ((@IsNull_manghiepvu = 1 AND [manghiepvu] IS NULL) OR ([manghiepvu] = @Original_manghiepvu)) AND ((@IsNull_taikhoanthue = 1 AND [taikhoanthue] IS NULL) OR ([taikhoanthue] = @Original_taikhoanthue)) AND ((@IsNull_sochungtu = 1 AND [sochungtu] IS NULL) OR ([sochungtu] = @Original_sochungtu)) AND ((@IsNull_ngaychungtu = 1 AND [ngaychungtu] IS NULL) OR ([ngaychungtu] = @Original_ngaychungtu)) AND ((@IsNull_sohoadon = 1 AND [sohoadon] IS NULL) OR ([sohoadon] = @Original_sohoadon)) AND ((@IsNull_serial = 1 AND [serial] IS NULL) OR ([serial] = @Original_serial)) AND ((@IsNull_loaihoadon = 1 AND [loaihoadon] IS NULL) OR ([loaihoadon] = @Original_loaihoadon)) AND ((@IsNull_ngayhoadon = 1 AND [ngayhoadon] IS NULL) OR ([ngayhoadon] = @Original_ngayhoadon)) AND ((@IsNull_diengiaithue = 1 AND [diengiaithue] IS NULL) OR ([diengiaithue] = @Original_diengiaithue)) AND ((@IsNull_madonviuid = 1 AND [madonviuid] IS NULL) OR ([madonviuid] = @Original_madonviuid)) AND ((@IsNull_madonvi = 1 AND [madonvi] IS NULL) OR ([madonvi] = @Original_madonvi)) AND ((@IsNull_tendonvi = 1 AND [tendonvi] IS NULL) OR ([tendonvi] = @Original_tendonvi)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_doanhthu = 1 AND [doanhthu] IS NULL) OR ([doanhthu] = @Original_doanhthu)) AND ((@IsNull_phantramthue = 1 AND [phantramthue] IS NULL) OR ([phantramthue] = @Original_phantramthue)) AND ((@IsNull_tienthue = 1 AND [tienthue] IS NULL) OR ([tienthue] = @Original_tienthue)) AND ((@IsNull_tongcong = 1 AND [tongcong] IS NULL) OR ([tongcong] = @Original_tongcong)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([uid] = @Original_uid) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_manghiepvu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_manghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanthue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanthue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanthue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sochungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaychungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_serial" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="serial" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_serial" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="serial" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaihoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaihoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaihoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayhoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diengiaithue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diengiaithue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diengiaithue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiaithue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_madonviuid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="madonviuid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_madonviuid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="madonviuid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_madonvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="madonvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_madonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madonvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tendonvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tendonvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tendonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendonvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_doanhthu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="doanhthu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_doanhthu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="doanhthu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phantramthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phantramthue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_phantramthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phantramthue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tienthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tienthue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tienthue" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienthue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tongcong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tongcong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tongcong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tongcong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[BH_BanHangThue] ([ma], [manghiepvu], [taikhoanthue], [sochungtu], [ngaychungtu], [sohoadon], [serial], [loaihoadon], [ngayhoadon], [diengiaithue], [madonviuid], [madonvi], [tendonvi], [diachi], [masothue], [doanhthu], [phantramthue], [tienthue], [tongcong], [tinhtrang], [chinhanh], [uid]) VALUES (@ma, @manghiepvu, @taikhoanthue, @sochungtu, @ngaychungtu, @sohoadon, @serial, @loaihoadon, @ngayhoadon, @diengiaithue, @madonviuid, @madonvi, @tendonvi, @diachi, @masothue, @doanhthu, @phantramthue, @tienthue, @tongcong, @tinhtrang, @chinhanh, @uid);
SELECT ma, manghiepvu, taikhoanthue, sochungtu, ngaychungtu, sohoadon, serial, loaihoadon, ngayhoadon, diengiaithue, madonviuid, madonvi, tendonvi, diachi, masothue, doanhthu, phantramthue, tienthue, tongcong, tinhtrang, chinhanh, uid, id FROM BH_BanHangThue WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanthue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanthue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@serial" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="serial" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaihoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diengiaithue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiaithue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@madonviuid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="madonviuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@madonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madonvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tendonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendonvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@doanhthu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="doanhthu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@phantramthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phantramthue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tienthue" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienthue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tongcong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tongcong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, manghiepvu, taikhoanthue, sochungtu, ngaychungtu, sohoadon, serial, loaihoadon, ngayhoadon, diengiaithue, madonviuid, madonvi, tendonvi, diachi, masothue, doanhthu, phantramthue, tienthue, tongcong, tinhtrang, chinhanh, uid, id FROM dbo.BH_BanHangThue</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[BH_BanHangThue] SET [ma] = @ma, [manghiepvu] = @manghiepvu, [taikhoanthue] = @taikhoanthue, [sochungtu] = @sochungtu, [ngaychungtu] = @ngaychungtu, [sohoadon] = @sohoadon, [serial] = @serial, [loaihoadon] = @loaihoadon, [ngayhoadon] = @ngayhoadon, [diengiaithue] = @diengiaithue, [madonviuid] = @madonviuid, [madonvi] = @madonvi, [tendonvi] = @tendonvi, [diachi] = @diachi, [masothue] = @masothue, [doanhthu] = @doanhthu, [phantramthue] = @phantramthue, [tienthue] = @tienthue, [tongcong] = @tongcong, [tinhtrang] = @tinhtrang, [chinhanh] = @chinhanh, [uid] = @uid WHERE (([ma] = @Original_ma) AND ((@IsNull_manghiepvu = 1 AND [manghiepvu] IS NULL) OR ([manghiepvu] = @Original_manghiepvu)) AND ((@IsNull_taikhoanthue = 1 AND [taikhoanthue] IS NULL) OR ([taikhoanthue] = @Original_taikhoanthue)) AND ((@IsNull_sochungtu = 1 AND [sochungtu] IS NULL) OR ([sochungtu] = @Original_sochungtu)) AND ((@IsNull_ngaychungtu = 1 AND [ngaychungtu] IS NULL) OR ([ngaychungtu] = @Original_ngaychungtu)) AND ((@IsNull_sohoadon = 1 AND [sohoadon] IS NULL) OR ([sohoadon] = @Original_sohoadon)) AND ((@IsNull_serial = 1 AND [serial] IS NULL) OR ([serial] = @Original_serial)) AND ((@IsNull_loaihoadon = 1 AND [loaihoadon] IS NULL) OR ([loaihoadon] = @Original_loaihoadon)) AND ((@IsNull_ngayhoadon = 1 AND [ngayhoadon] IS NULL) OR ([ngayhoadon] = @Original_ngayhoadon)) AND ((@IsNull_diengiaithue = 1 AND [diengiaithue] IS NULL) OR ([diengiaithue] = @Original_diengiaithue)) AND ((@IsNull_madonviuid = 1 AND [madonviuid] IS NULL) OR ([madonviuid] = @Original_madonviuid)) AND ((@IsNull_madonvi = 1 AND [madonvi] IS NULL) OR ([madonvi] = @Original_madonvi)) AND ((@IsNull_tendonvi = 1 AND [tendonvi] IS NULL) OR ([tendonvi] = @Original_tendonvi)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_doanhthu = 1 AND [doanhthu] IS NULL) OR ([doanhthu] = @Original_doanhthu)) AND ((@IsNull_phantramthue = 1 AND [phantramthue] IS NULL) OR ([phantramthue] = @Original_phantramthue)) AND ((@IsNull_tienthue = 1 AND [tienthue] IS NULL) OR ([tienthue] = @Original_tienthue)) AND ((@IsNull_tongcong = 1 AND [tongcong] IS NULL) OR ([tongcong] = @Original_tongcong)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([uid] = @Original_uid) AND ([id] = @Original_id));
SELECT ma, manghiepvu, taikhoanthue, sochungtu, ngaychungtu, sohoadon, serial, loaihoadon, ngayhoadon, diengiaithue, madonviuid, madonvi, tendonvi, diachi, masothue, doanhthu, phantramthue, tienthue, tongcong, tinhtrang, chinhanh, uid, id FROM BH_BanHangThue WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taikhoanthue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanthue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@serial" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="serial" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaihoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diengiaithue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiaithue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@madonviuid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="madonviuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@madonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madonvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tendonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendonvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@doanhthu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="doanhthu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@phantramthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phantramthue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tienthue" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienthue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tongcong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tongcong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_manghiepvu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_manghiepvu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manghiepvu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taikhoanthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taikhoanthue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taikhoanthue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taikhoanthue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sochungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sochungtu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sochungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaychungtu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaychungtu" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaychungtu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_serial" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="serial" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_serial" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="serial" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaihoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaihoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaihoadon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayhoadon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayhoadon" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayhoadon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diengiaithue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diengiaithue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diengiaithue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diengiaithue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_madonviuid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="madonviuid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_madonviuid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="madonviuid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_madonvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="madonvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_madonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madonvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tendonvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tendonvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tendonvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendonvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_doanhthu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="doanhthu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_doanhthu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="doanhthu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phantramthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phantramthue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_phantramthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phantramthue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tienthue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tienthue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tienthue" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tienthue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tongcong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tongcong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tongcong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tongcong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="PCV_GDP.dbo.BH_BanHangThue" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="manghiepvu" DataSetColumn="manghiepvu" />
              <Mapping SourceColumn="taikhoanthue" DataSetColumn="taikhoanthue" />
              <Mapping SourceColumn="sochungtu" DataSetColumn="sochungtu" />
              <Mapping SourceColumn="ngaychungtu" DataSetColumn="ngaychungtu" />
              <Mapping SourceColumn="sohoadon" DataSetColumn="sohoadon" />
              <Mapping SourceColumn="serial" DataSetColumn="serial" />
              <Mapping SourceColumn="loaihoadon" DataSetColumn="loaihoadon" />
              <Mapping SourceColumn="ngayhoadon" DataSetColumn="ngayhoadon" />
              <Mapping SourceColumn="diengiaithue" DataSetColumn="diengiaithue" />
              <Mapping SourceColumn="madonviuid" DataSetColumn="madonviuid" />
              <Mapping SourceColumn="madonvi" DataSetColumn="madonvi" />
              <Mapping SourceColumn="tendonvi" DataSetColumn="tendonvi" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="masothue" DataSetColumn="masothue" />
              <Mapping SourceColumn="doanhthu" DataSetColumn="doanhthu" />
              <Mapping SourceColumn="phantramthue" DataSetColumn="phantramthue" />
              <Mapping SourceColumn="tienthue" DataSetColumn="tienthue" />
              <Mapping SourceColumn="tongcong" DataSetColumn="tongcong" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="uid" DataSetColumn="uid" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSachTableAdapter" GeneratorDataComponentClassName="getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSachTableAdapter" Name="getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSach" UserDataComponentName="getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSachTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_GDPConnectionString (MySettings)" DbObjectName="PCV_GDP.dbo.getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSach" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSach</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@manhinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="loaicontrol" DataSetColumn="loaicontrol" />
              <Mapping SourceColumn="control" DataSetColumn="control" />
              <Mapping SourceColumn="xem" DataSetColumn="xem" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DM_KhachHangTableAdapter" GeneratorDataComponentClassName="DM_KhachHangTableAdapter" Name="DM_KhachHang" UserDataComponentName="DM_KhachHangTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_GDPConnectionString (MySettings)" DbObjectName="PCV_GDP.dbo.DM_KhachHang" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DM_KhachHang] ([mauid], [ma], [ten], [diachi]) VALUES (@mauid, @ma, @ten, @diachi)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@mauid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="mauid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT mauid, ma, ten, diachi FROM dbo.DM_KhachHang</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="mauid" DataSetColumn="mauid" />
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="PCV_GDPDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="PCV_GDPDataSet" msprop:Generator_UserDSName="PCV_GDPDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="BH_BanHang" msprop:Generator_TableClassName="BH_BanHangDataTable" msprop:Generator_TableVarName="tableBH_BanHang" msprop:Generator_RowChangedName="BH_BanHangRowChanged" msprop:Generator_TablePropName="BH_BanHang" msprop:Generator_RowDeletingName="BH_BanHangRowDeleting" msprop:Generator_RowChangingName="BH_BanHangRowChanging" msprop:Generator_RowEvHandlerName="BH_BanHangRowChangeEventHandler" msprop:Generator_RowDeletedName="BH_BanHangRowDeleted" msprop:Generator_RowClassName="BH_BanHangRow" msprop:Generator_UserTableName="BH_BanHang" msprop:Generator_RowEvArgName="BH_BanHangRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="manghiepvu" msprop:Generator_ColumnVarNameInTable="columnmanghiepvu" msprop:Generator_ColumnPropNameInRow="manghiepvu" msprop:Generator_ColumnPropNameInTable="manghiepvuColumn" msprop:Generator_UserColumnName="manghiepvu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sochungtu" msprop:Generator_ColumnVarNameInTable="columnsochungtu" msprop:Generator_ColumnPropNameInRow="sochungtu" msprop:Generator_ColumnPropNameInTable="sochungtuColumn" msprop:Generator_UserColumnName="sochungtu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaychungtu" msprop:Generator_ColumnVarNameInTable="columnngaychungtu" msprop:Generator_ColumnPropNameInRow="ngaychungtu" msprop:Generator_ColumnPropNameInTable="ngaychungtuColumn" msprop:Generator_UserColumnName="ngaychungtu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="sohoadon" msprop:Generator_ColumnVarNameInTable="columnsohoadon" msprop:Generator_ColumnPropNameInRow="sohoadon" msprop:Generator_ColumnPropNameInTable="sohoadonColumn" msprop:Generator_UserColumnName="sohoadon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngayhoadon" msprop:Generator_ColumnVarNameInTable="columnngayhoadon" msprop:Generator_ColumnPropNameInRow="ngayhoadon" msprop:Generator_ColumnPropNameInTable="ngayhoadonColumn" msprop:Generator_UserColumnName="ngayhoadon" type="xs:dateTime" minOccurs="0" />
              <xs:element name="sotokhaiHQ" msprop:Generator_ColumnVarNameInTable="columnsotokhaiHQ" msprop:Generator_ColumnPropNameInRow="sotokhaiHQ" msprop:Generator_ColumnPropNameInTable="sotokhaiHQColumn" msprop:Generator_UserColumnName="sotokhaiHQ" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaytokhaiHQ" msprop:Generator_ColumnVarNameInTable="columnngaytokhaiHQ" msprop:Generator_ColumnPropNameInRow="ngaytokhaiHQ" msprop:Generator_ColumnPropNameInTable="ngaytokhaiHQColumn" msprop:Generator_UserColumnName="ngaytokhaiHQ" type="xs:dateTime" minOccurs="0" />
              <xs:element name="makhachhanguid" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnmakhachhanguid" msprop:Generator_ColumnPropNameInRow="makhachhanguid" msprop:Generator_ColumnPropNameInTable="makhachhanguidColumn" msprop:Generator_UserColumnName="makhachhanguid" type="xs:string" minOccurs="0" />
              <xs:element name="makhachhang" msprop:Generator_ColumnVarNameInTable="columnmakhachhang" msprop:Generator_ColumnPropNameInRow="makhachhang" msprop:Generator_ColumnPropNameInTable="makhachhangColumn" msprop:Generator_UserColumnName="makhachhang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenkhachhang" msprop:Generator_ColumnVarNameInTable="columntenkhachhang" msprop:Generator_ColumnPropNameInRow="tenkhachhang" msprop:Generator_ColumnPropNameInTable="tenkhachhangColumn" msprop:Generator_UserColumnName="tenkhachhang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="soSO" msprop:Generator_ColumnVarNameInTable="columnsoSO" msprop:Generator_ColumnPropNameInRow="soSO" msprop:Generator_ColumnPropNameInTable="soSOColumn" msprop:Generator_UserColumnName="soSO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hinhthucthanhtoan" msprop:Generator_ColumnVarNameInTable="columnhinhthucthanhtoan" msprop:Generator_ColumnPropNameInRow="hinhthucthanhtoan" msprop:Generator_ColumnPropNameInTable="hinhthucthanhtoanColumn" msprop:Generator_UserColumnName="hinhthucthanhtoan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaythanhtoan" msprop:Generator_ColumnVarNameInTable="columnngaythanhtoan" msprop:Generator_ColumnPropNameInRow="ngaythanhtoan" msprop:Generator_ColumnPropNameInTable="ngaythanhtoanColumn" msprop:Generator_UserColumnName="ngaythanhtoan" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dieukiengiaohang" msprop:Generator_ColumnVarNameInTable="columndieukiengiaohang" msprop:Generator_ColumnPropNameInRow="dieukiengiaohang" msprop:Generator_ColumnPropNameInTable="dieukiengiaohangColumn" msprop:Generator_UserColumnName="dieukiengiaohang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tygiatokhaiHQ" msprop:Generator_ColumnVarNameInTable="columntygiatokhaiHQ" msprop:Generator_ColumnPropNameInRow="tygiatokhaiHQ" msprop:Generator_ColumnPropNameInTable="tygiatokhaiHQColumn" msprop:Generator_UserColumnName="tygiatokhaiHQ" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diengiai" msprop:Generator_ColumnVarNameInTable="columndiengiai" msprop:Generator_ColumnPropNameInRow="diengiai" msprop:Generator_ColumnPropNameInTable="diengiaiColumn" msprop:Generator_UserColumnName="diengiai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loaitien" msprop:Generator_ColumnVarNameInTable="columnloaitien" msprop:Generator_ColumnPropNameInRow="loaitien" msprop:Generator_ColumnPropNameInTable="loaitienColumn" msprop:Generator_UserColumnName="loaitien" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tygianganhang" msprop:Generator_ColumnVarNameInTable="columntygianganhang" msprop:Generator_ColumnPropNameInRow="tygianganhang" msprop:Generator_ColumnPropNameInTable="tygianganhangColumn" msprop:Generator_UserColumnName="tygianganhang" type="xs:decimal" minOccurs="0" />
              <xs:element name="nguyente" msprop:Generator_ColumnVarNameInTable="columnnguyente" msprop:Generator_ColumnPropNameInRow="nguyente" msprop:Generator_ColumnPropNameInTable="nguyenteColumn" msprop:Generator_UserColumnName="nguyente" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtienvnd" msprop:Generator_ColumnVarNameInTable="columnthanhtienvnd" msprop:Generator_ColumnPropNameInRow="thanhtienvnd" msprop:Generator_ColumnPropNameInTable="thanhtienvndColumn" msprop:Generator_UserColumnName="thanhtienvnd" type="xs:decimal" minOccurs="0" />
              <xs:element name="phuongtienvanchuyen" msprop:Generator_ColumnVarNameInTable="columnphuongtienvanchuyen" msprop:Generator_ColumnPropNameInRow="phuongtienvanchuyen" msprop:Generator_ColumnPropNameInTable="phuongtienvanchuyenColumn" msprop:Generator_UserColumnName="phuongtienvanchuyen" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nhanviensale" msprop:Generator_ColumnVarNameInTable="columnnhanviensale" msprop:Generator_ColumnPropNameInRow="nhanviensale" msprop:Generator_ColumnPropNameInTable="nhanviensaleColumn" msprop:Generator_UserColumnName="nhanviensale" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="phongban" msprop:Generator_ColumnVarNameInTable="columnphongban" msprop:Generator_ColumnPropNameInRow="phongban" msprop:Generator_ColumnPropNameInTable="phongbanColumn" msprop:Generator_UserColumnName="phongban" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="machuongtrinhkhuyenmai" msprop:Generator_ColumnVarNameInTable="columnmachuongtrinhkhuyenmai" msprop:Generator_ColumnPropNameInRow="machuongtrinhkhuyenmai" msprop:Generator_ColumnPropNameInTable="machuongtrinhkhuyenmaiColumn" msprop:Generator_UserColumnName="machuongtrinhkhuyenmai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="banggia" msprop:Generator_ColumnVarNameInTable="columnbanggia" msprop:Generator_ColumnPropNameInRow="banggia" msprop:Generator_ColumnPropNameInTable="banggiaColumn" msprop:Generator_UserColumnName="banggia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sohopdong" msprop:Generator_ColumnVarNameInTable="columnsohopdong" msprop:Generator_ColumnPropNameInRow="sohopdong" msprop:Generator_ColumnPropNameInTable="sohopdongColumn" msprop:Generator_UserColumnName="sohopdong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="kyketoan" msprop:Generator_ColumnVarNameInTable="columnkyketoan" msprop:Generator_ColumnPropNameInRow="kyketoan" msprop:Generator_ColumnPropNameInTable="kyketoanColumn" msprop:Generator_UserColumnName="kyketoan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loai" msprop:Generator_ColumnVarNameInTable="columnloai" msprop:Generator_ColumnPropNameInRow="loai" msprop:Generator_ColumnPropNameInTable="loaiColumn" msprop:Generator_UserColumnName="loai" type="xs:int" minOccurs="0" />
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="BH_BanHangChiTiet" msprop:Generator_TableClassName="BH_BanHangChiTietDataTable" msprop:Generator_TableVarName="tableBH_BanHangChiTiet" msprop:Generator_RowChangedName="BH_BanHangChiTietRowChanged" msprop:Generator_TablePropName="BH_BanHangChiTiet" msprop:Generator_RowDeletingName="BH_BanHangChiTietRowDeleting" msprop:Generator_RowChangingName="BH_BanHangChiTietRowChanging" msprop:Generator_RowEvHandlerName="BH_BanHangChiTietRowChangeEventHandler" msprop:Generator_RowDeletedName="BH_BanHangChiTietRowDeleted" msprop:Generator_RowClassName="BH_BanHangChiTietRow" msprop:Generator_UserTableName="BH_BanHangChiTiet" msprop:Generator_RowEvArgName="BH_BanHangChiTietRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="manghiepvu" msprop:Generator_ColumnVarNameInTable="columnmanghiepvu" msprop:Generator_ColumnPropNameInRow="manghiepvu" msprop:Generator_ColumnPropNameInTable="manghiepvuColumn" msprop:Generator_UserColumnName="manghiepvu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sochungtu" msprop:Generator_ColumnVarNameInTable="columnsochungtu" msprop:Generator_ColumnPropNameInRow="sochungtu" msprop:Generator_ColumnPropNameInTable="sochungtuColumn" msprop:Generator_UserColumnName="sochungtu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaychungtu" msprop:Generator_ColumnVarNameInTable="columnngaychungtu" msprop:Generator_ColumnPropNameInRow="ngaychungtu" msprop:Generator_ColumnPropNameInTable="ngaychungtuColumn" msprop:Generator_UserColumnName="ngaychungtu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="sohoadon" msprop:Generator_ColumnVarNameInTable="columnsohoadon" msprop:Generator_ColumnPropNameInRow="sohoadon" msprop:Generator_ColumnPropNameInTable="sohoadonColumn" msprop:Generator_UserColumnName="sohoadon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngayhoadon" msprop:Generator_ColumnVarNameInTable="columnngayhoadon" msprop:Generator_ColumnPropNameInRow="ngayhoadon" msprop:Generator_ColumnPropNameInTable="ngayhoadonColumn" msprop:Generator_UserColumnName="ngayhoadon" type="xs:dateTime" minOccurs="0" />
              <xs:element name="taikhoanno" msprop:Generator_ColumnVarNameInTable="columntaikhoanno" msprop:Generator_ColumnPropNameInRow="taikhoanno" msprop:Generator_ColumnPropNameInTable="taikhoannoColumn" msprop:Generator_UserColumnName="taikhoanno" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="taikhoanco" msprop:Generator_ColumnVarNameInTable="columntaikhoanco" msprop:Generator_ColumnPropNameInRow="taikhoanco" msprop:Generator_ColumnPropNameInTable="taikhoancoColumn" msprop:Generator_UserColumnName="taikhoanco" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="madonviuid" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnmadonviuid" msprop:Generator_ColumnPropNameInRow="madonviuid" msprop:Generator_ColumnPropNameInTable="madonviuidColumn" msprop:Generator_UserColumnName="madonviuid" type="xs:string" minOccurs="0" />
              <xs:element name="madonvi" msprop:Generator_ColumnVarNameInTable="columnmadonvi" msprop:Generator_ColumnPropNameInRow="madonvi" msprop:Generator_ColumnPropNameInTable="madonviColumn" msprop:Generator_UserColumnName="madonvi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tendonvi" msprop:Generator_ColumnVarNameInTable="columntendonvi" msprop:Generator_ColumnPropNameInRow="tendonvi" msprop:Generator_ColumnPropNameInTable="tendonviColumn" msprop:Generator_UserColumnName="tendonvi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachidonvi" msprop:Generator_ColumnVarNameInTable="columndiachidonvi" msprop:Generator_ColumnPropNameInRow="diachidonvi" msprop:Generator_ColumnPropNameInTable="diachidonviColumn" msprop:Generator_UserColumnName="diachidonvi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diengiai" msprop:Generator_ColumnVarNameInTable="columndiengiai" msprop:Generator_ColumnPropNameInRow="diengiai" msprop:Generator_ColumnPropNameInTable="diengiaiColumn" msprop:Generator_UserColumnName="diengiai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mafifo" msprop:Generator_ColumnVarNameInTable="columnmafifo" msprop:Generator_ColumnPropNameInRow="mafifo" msprop:Generator_ColumnPropNameInTable="mafifoColumn" msprop:Generator_UserColumnName="mafifo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mahanguid" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnmahanguid" msprop:Generator_ColumnPropNameInRow="mahanguid" msprop:Generator_ColumnPropNameInTable="mahanguidColumn" msprop:Generator_UserColumnName="mahanguid" type="xs:string" minOccurs="0" />
              <xs:element name="mahang" msprop:Generator_ColumnVarNameInTable="columnmahang" msprop:Generator_ColumnPropNameInRow="mahang" msprop:Generator_ColumnPropNameInTable="mahangColumn" msprop:Generator_UserColumnName="mahang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenhang" msprop:Generator_ColumnVarNameInTable="columntenhang" msprop:Generator_ColumnPropNameInRow="tenhang" msprop:Generator_ColumnPropNameInTable="tenhangColumn" msprop:Generator_UserColumnName="tenhang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="solo" msprop:Generator_ColumnVarNameInTable="columnsolo" msprop:Generator_ColumnPropNameInRow="solo" msprop:Generator_ColumnPropNameInTable="soloColumn" msprop:Generator_UserColumnName="solo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hsd" msprop:Generator_ColumnVarNameInTable="columnhsd" msprop:Generator_ColumnPropNameInRow="hsd" msprop:Generator_ColumnPropNameInTable="hsdColumn" msprop:Generator_UserColumnName="hsd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="quicach" msprop:Generator_ColumnVarNameInTable="columnquicach" msprop:Generator_ColumnPropNameInRow="quicach" msprop:Generator_ColumnPropNameInTable="quicachColumn" msprop:Generator_UserColumnName="quicach" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dvt" msprop:Generator_ColumnVarNameInTable="columndvt" msprop:Generator_ColumnPropNameInRow="dvt" msprop:Generator_ColumnPropNameInTable="dvtColumn" msprop:Generator_UserColumnName="dvt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="soluongso" msprop:Generator_ColumnVarNameInTable="columnsoluongso" msprop:Generator_ColumnPropNameInRow="soluongso" msprop:Generator_ColumnPropNameInTable="soluongsoColumn" msprop:Generator_UserColumnName="soluongso" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluonggiao" msprop:Generator_ColumnVarNameInTable="columnsoluonggiao" msprop:Generator_ColumnPropNameInRow="soluonggiao" msprop:Generator_ColumnPropNameInTable="soluonggiaoColumn" msprop:Generator_UserColumnName="soluonggiao" type="xs:decimal" minOccurs="0" />
              <xs:element name="dongianguyente" msprop:Generator_ColumnVarNameInTable="columndongianguyente" msprop:Generator_ColumnPropNameInRow="dongianguyente" msprop:Generator_ColumnPropNameInTable="dongianguyenteColumn" msprop:Generator_UserColumnName="dongianguyente" type="xs:decimal" minOccurs="0" />
              <xs:element name="dongiavnd" msprop:Generator_ColumnVarNameInTable="columndongiavnd" msprop:Generator_ColumnPropNameInRow="dongiavnd" msprop:Generator_ColumnPropNameInTable="dongiavndColumn" msprop:Generator_UserColumnName="dongiavnd" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtiennguyente" msprop:Generator_ColumnVarNameInTable="columnthanhtiennguyente" msprop:Generator_ColumnPropNameInRow="thanhtiennguyente" msprop:Generator_ColumnPropNameInTable="thanhtiennguyenteColumn" msprop:Generator_UserColumnName="thanhtiennguyente" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtienvnd" msprop:Generator_ColumnVarNameInTable="columnthanhtienvnd" msprop:Generator_ColumnPropNameInRow="thanhtienvnd" msprop:Generator_ColumnPropNameInTable="thanhtienvndColumn" msprop:Generator_UserColumnName="thanhtienvnd" type="xs:decimal" minOccurs="0" />
              <xs:element name="tilethuegtgt" msprop:Generator_ColumnVarNameInTable="columntilethuegtgt" msprop:Generator_ColumnPropNameInRow="tilethuegtgt" msprop:Generator_ColumnPropNameInTable="tilethuegtgtColumn" msprop:Generator_UserColumnName="tilethuegtgt" type="xs:int" minOccurs="0" />
              <xs:element name="tienthuegtgt" msprop:Generator_ColumnVarNameInTable="columntienthuegtgt" msprop:Generator_ColumnPropNameInRow="tienthuegtgt" msprop:Generator_ColumnPropNameInTable="tienthuegtgtColumn" msprop:Generator_UserColumnName="tienthuegtgt" type="xs:decimal" minOccurs="0" />
              <xs:element name="taikhoanthuegtgt" msprop:Generator_ColumnVarNameInTable="columntaikhoanthuegtgt" msprop:Generator_ColumnPropNameInRow="taikhoanthuegtgt" msprop:Generator_ColumnPropNameInTable="taikhoanthuegtgtColumn" msprop:Generator_UserColumnName="taikhoanthuegtgt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chiphiban" msprop:Generator_ColumnVarNameInTable="columnchiphiban" msprop:Generator_ColumnPropNameInRow="chiphiban" msprop:Generator_ColumnPropNameInTable="chiphibanColumn" msprop:Generator_UserColumnName="chiphiban" type="xs:decimal" minOccurs="0" />
              <xs:element name="tilethuenk" msprop:Generator_ColumnVarNameInTable="columntilethuenk" msprop:Generator_ColumnPropNameInRow="tilethuenk" msprop:Generator_ColumnPropNameInTable="tilethuenkColumn" msprop:Generator_UserColumnName="tilethuenk" type="xs:int" minOccurs="0" />
              <xs:element name="tienthuenk" msprop:Generator_ColumnVarNameInTable="columntienthuenk" msprop:Generator_ColumnPropNameInRow="tienthuenk" msprop:Generator_ColumnPropNameInTable="tienthuenkColumn" msprop:Generator_UserColumnName="tienthuenk" type="xs:decimal" minOccurs="0" />
              <xs:element name="taikhoanthuenk" msprop:Generator_ColumnVarNameInTable="columntaikhoanthuenk" msprop:Generator_ColumnPropNameInRow="taikhoanthuenk" msprop:Generator_ColumnPropNameInTable="taikhoanthuenkColumn" msprop:Generator_UserColumnName="taikhoanthuenk" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="taikhoanchietkhau" msprop:Generator_ColumnVarNameInTable="columntaikhoanchietkhau" msprop:Generator_ColumnPropNameInRow="taikhoanchietkhau" msprop:Generator_ColumnPropNameInTable="taikhoanchietkhauColumn" msprop:Generator_UserColumnName="taikhoanchietkhau" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chietkhau" msprop:Generator_ColumnVarNameInTable="columnchietkhau" msprop:Generator_ColumnPropNameInRow="chietkhau" msprop:Generator_ColumnPropNameInTable="chietkhauColumn" msprop:Generator_UserColumnName="chietkhau" type="xs:int" minOccurs="0" />
              <xs:element name="nhomhd" msprop:Generator_ColumnVarNameInTable="columnnhomhd" msprop:Generator_ColumnPropNameInRow="nhomhd" msprop:Generator_ColumnPropNameInTable="nhomhdColumn" msprop:Generator_UserColumnName="nhomhd" type="xs:int" minOccurs="0" />
              <xs:element name="chenhlech" msprop:Generator_ColumnVarNameInTable="columnchenhlech" msprop:Generator_ColumnPropNameInRow="chenhlech" msprop:Generator_ColumnPropNameInTable="chenhlechColumn" msprop:Generator_UserColumnName="chenhlech" type="xs:decimal" minOccurs="0" />
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="kyketoan" msprop:Generator_ColumnVarNameInTable="columnkyketoan" msprop:Generator_ColumnPropNameInRow="kyketoan" msprop:Generator_ColumnPropNameInTable="kyketoanColumn" msprop:Generator_UserColumnName="kyketoan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loai" msprop:Generator_ColumnVarNameInTable="columnloai" msprop:Generator_ColumnPropNameInRow="loai" msprop:Generator_ColumnPropNameInTable="loaiColumn" msprop:Generator_UserColumnName="loai" type="xs:int" minOccurs="0" />
              <xs:element name="uid" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnuid" msprop:Generator_ColumnPropNameInRow="uid" msprop:Generator_ColumnPropNameInTable="uidColumn" msprop:Generator_UserColumnName="uid" type="xs:string" />
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="BH_BanHangThue" msprop:Generator_TableClassName="BH_BanHangThueDataTable" msprop:Generator_TableVarName="tableBH_BanHangThue" msprop:Generator_RowChangedName="BH_BanHangThueRowChanged" msprop:Generator_TablePropName="BH_BanHangThue" msprop:Generator_RowDeletingName="BH_BanHangThueRowDeleting" msprop:Generator_RowChangingName="BH_BanHangThueRowChanging" msprop:Generator_RowEvHandlerName="BH_BanHangThueRowChangeEventHandler" msprop:Generator_RowDeletedName="BH_BanHangThueRowDeleted" msprop:Generator_RowClassName="BH_BanHangThueRow" msprop:Generator_UserTableName="BH_BanHangThue" msprop:Generator_RowEvArgName="BH_BanHangThueRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="manghiepvu" msprop:Generator_ColumnVarNameInTable="columnmanghiepvu" msprop:Generator_ColumnPropNameInRow="manghiepvu" msprop:Generator_ColumnPropNameInTable="manghiepvuColumn" msprop:Generator_UserColumnName="manghiepvu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="taikhoanthue" msprop:Generator_ColumnVarNameInTable="columntaikhoanthue" msprop:Generator_ColumnPropNameInRow="taikhoanthue" msprop:Generator_ColumnPropNameInTable="taikhoanthueColumn" msprop:Generator_UserColumnName="taikhoanthue" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sochungtu" msprop:Generator_ColumnVarNameInTable="columnsochungtu" msprop:Generator_ColumnPropNameInRow="sochungtu" msprop:Generator_ColumnPropNameInTable="sochungtuColumn" msprop:Generator_UserColumnName="sochungtu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaychungtu" msprop:Generator_ColumnVarNameInTable="columnngaychungtu" msprop:Generator_ColumnPropNameInRow="ngaychungtu" msprop:Generator_ColumnPropNameInTable="ngaychungtuColumn" msprop:Generator_UserColumnName="ngaychungtu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="sohoadon" msprop:Generator_ColumnVarNameInTable="columnsohoadon" msprop:Generator_ColumnPropNameInRow="sohoadon" msprop:Generator_ColumnPropNameInTable="sohoadonColumn" msprop:Generator_UserColumnName="sohoadon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="serial" msprop:Generator_ColumnVarNameInTable="columnserial" msprop:Generator_ColumnPropNameInRow="serial" msprop:Generator_ColumnPropNameInTable="serialColumn" msprop:Generator_UserColumnName="serial" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loaihoadon" msprop:Generator_ColumnVarNameInTable="columnloaihoadon" msprop:Generator_ColumnPropNameInRow="loaihoadon" msprop:Generator_ColumnPropNameInTable="loaihoadonColumn" msprop:Generator_UserColumnName="loaihoadon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngayhoadon" msprop:Generator_ColumnVarNameInTable="columnngayhoadon" msprop:Generator_ColumnPropNameInRow="ngayhoadon" msprop:Generator_ColumnPropNameInTable="ngayhoadonColumn" msprop:Generator_UserColumnName="ngayhoadon" type="xs:dateTime" minOccurs="0" />
              <xs:element name="diengiaithue" msprop:Generator_ColumnVarNameInTable="columndiengiaithue" msprop:Generator_ColumnPropNameInRow="diengiaithue" msprop:Generator_ColumnPropNameInTable="diengiaithueColumn" msprop:Generator_UserColumnName="diengiaithue" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="madonviuid" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnmadonviuid" msprop:Generator_ColumnPropNameInRow="madonviuid" msprop:Generator_ColumnPropNameInTable="madonviuidColumn" msprop:Generator_UserColumnName="madonviuid" type="xs:string" minOccurs="0" />
              <xs:element name="madonvi" msprop:Generator_ColumnVarNameInTable="columnmadonvi" msprop:Generator_ColumnPropNameInRow="madonvi" msprop:Generator_ColumnPropNameInTable="madonviColumn" msprop:Generator_UserColumnName="madonvi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tendonvi" msprop:Generator_ColumnVarNameInTable="columntendonvi" msprop:Generator_ColumnPropNameInRow="tendonvi" msprop:Generator_ColumnPropNameInTable="tendonviColumn" msprop:Generator_UserColumnName="tendonvi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="masothue" msprop:Generator_ColumnVarNameInTable="columnmasothue" msprop:Generator_ColumnPropNameInRow="masothue" msprop:Generator_ColumnPropNameInTable="masothueColumn" msprop:Generator_UserColumnName="masothue" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="doanhthu" msprop:Generator_ColumnVarNameInTable="columndoanhthu" msprop:Generator_ColumnPropNameInRow="doanhthu" msprop:Generator_ColumnPropNameInTable="doanhthuColumn" msprop:Generator_UserColumnName="doanhthu" type="xs:decimal" minOccurs="0" />
              <xs:element name="phantramthue" msprop:Generator_ColumnVarNameInTable="columnphantramthue" msprop:Generator_ColumnPropNameInRow="phantramthue" msprop:Generator_ColumnPropNameInTable="phantramthueColumn" msprop:Generator_UserColumnName="phantramthue" type="xs:int" minOccurs="0" />
              <xs:element name="tienthue" msprop:Generator_ColumnVarNameInTable="columntienthue" msprop:Generator_ColumnPropNameInRow="tienthue" msprop:Generator_ColumnPropNameInTable="tienthueColumn" msprop:Generator_UserColumnName="tienthue" type="xs:decimal" minOccurs="0" />
              <xs:element name="tongcong" msprop:Generator_ColumnVarNameInTable="columntongcong" msprop:Generator_ColumnPropNameInRow="tongcong" msprop:Generator_ColumnPropNameInTable="tongcongColumn" msprop:Generator_UserColumnName="tongcong" type="xs:decimal" minOccurs="0" />
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uid" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnuid" msprop:Generator_ColumnPropNameInRow="uid" msprop:Generator_ColumnPropNameInTable="uidColumn" msprop:Generator_UserColumnName="uid" type="xs:string" />
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSach" msprop:Generator_TableClassName="getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSachDataTable" msprop:Generator_TableVarName="tablegetPhanQuyenManHinh_FormDoi_ChiTiet_DanhSach" msprop:Generator_RowChangedName="getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSachRowChanged" msprop:Generator_TablePropName="getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSach" msprop:Generator_RowDeletingName="getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSachRowDeleting" msprop:Generator_RowChangingName="getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSachRowChanging" msprop:Generator_RowEvHandlerName="getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSachRowChangeEventHandler" msprop:Generator_RowDeletedName="getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSachRowDeleted" msprop:Generator_RowClassName="getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSachRow" msprop:Generator_UserTableName="getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSach" msprop:Generator_RowEvArgName="getPhanQuyenManHinh_FormDoi_ChiTiet_DanhSachRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="loaicontrol" msprop:Generator_ColumnVarNameInTable="columnloaicontrol" msprop:Generator_ColumnPropNameInRow="loaicontrol" msprop:Generator_ColumnPropNameInTable="loaicontrolColumn" msprop:Generator_UserColumnName="loaicontrol" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="control" msprop:Generator_ColumnVarNameInTable="columncontrol" msprop:Generator_ColumnPropNameInRow="control" msprop:Generator_ColumnPropNameInTable="controlColumn" msprop:Generator_UserColumnName="control" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="xem" msprop:Generator_ColumnVarNameInTable="columnxem" msprop:Generator_ColumnPropNameInRow="xem" msprop:Generator_ColumnPropNameInTable="xemColumn" msprop:Generator_UserColumnName="xem" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DM_KhachHang" msprop:Generator_TableClassName="DM_KhachHangDataTable" msprop:Generator_TableVarName="tableDM_KhachHang" msprop:Generator_TablePropName="DM_KhachHang" msprop:Generator_RowDeletingName="DM_KhachHangRowDeleting" msprop:Generator_RowChangingName="DM_KhachHangRowChanging" msprop:Generator_RowEvHandlerName="DM_KhachHangRowChangeEventHandler" msprop:Generator_RowDeletedName="DM_KhachHangRowDeleted" msprop:Generator_UserTableName="DM_KhachHang" msprop:Generator_RowChangedName="DM_KhachHangRowChanged" msprop:Generator_RowEvArgName="DM_KhachHangRowChangeEvent" msprop:Generator_RowClassName="DM_KhachHangRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="mauid" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnmauid" msprop:Generator_ColumnPropNameInRow="mauid" msprop:Generator_ColumnPropNameInTable="mauidColumn" msprop:Generator_UserColumnName="mauid" type="xs:string" />
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BH_BanHang" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="BH_BanHangChiTiet_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BH_BanHangChiTiet" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="BH_BanHangThue_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BH_BanHangThue" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK__BH_BanHangCh__ma__793DFFAF" msdata:parent="BH_BanHang" msdata:child="BH_BanHangChiTiet" msdata:parentkey="ma" msdata:childkey="ma" msprop:Generator_UserChildTable="BH_BanHangChiTiet" msprop:Generator_ChildPropName="GetBH_BanHangChiTietRows" msprop:Generator_UserRelationName="FK__BH_BanHangCh__ma__793DFFAF" msprop:Generator_RelationVarName="relationFK__BH_BanHangCh__ma__793DFFAF" msprop:Generator_UserParentTable="BH_BanHang" msprop:Generator_ParentPropName="BH_BanHangRow" />
      <msdata:Relationship name="FK__BH_BanHangTh__ma__7A3223E8" msdata:parent="BH_BanHang" msdata:child="BH_BanHangThue" msdata:parentkey="ma" msdata:childkey="ma" msprop:Generator_UserChildTable="BH_BanHangThue" msprop:Generator_ChildPropName="GetBH_BanHangThueRows" msprop:Generator_UserRelationName="FK__BH_BanHangTh__ma__7A3223E8" msprop:Generator_RelationVarName="relationFK__BH_BanHangTh__ma__7A3223E8" msprop:Generator_UserParentTable="BH_BanHang" msprop:Generator_ParentPropName="BH_BanHangRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>